UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5aAVxQRlH8wZmdGp+aB7Dz4WxTf+oVpK1dVzV43DRXg='
WHERE
key_id = '9dd07ecd9ebf4f8f151b3881a51455eaabae02c9e9e8b6b5313340592316c971'
AND (
token = '5aAVxQRlH8wZmdGp+aB7Dz4WxTf+oVpK1dVzV43DRXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)