UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2U0ejJh3469ft+z92OgrCXfTf/3GhHwWoxKCG68+RN0='
WHERE
key_id = '1cbe09b3ea3148c58c97aa020271c4b1e40f4d696b8f7c7c32f7468edffa07d5'
AND (
token = '2U0ejJh3469ft+z92OgrCXfTf/3GhHwWoxKCG68+RN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)