UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BSs0YgFoKCb3RNh8JD6ylLqEMnqTp7IbG6X+V/2PjZg='
WHERE
key_id = '5c69c579e59f19d82a70e42efda7788890e3c2cf7a1bbd6a8791593ae30dc596'
AND (
token = 'BSs0YgFoKCb3RNh8JD6ylLqEMnqTp7IbG6X+V/2PjZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)