UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DeChhU9aAIHVKaRLy3kqg5QotQshuZUNUC+gYZix+RQ='
WHERE
key_id = '87a87ee3012e3ada85a598b474d38ded1bacf7b53bcdb36bd918fd60e54b03d5'
AND (
token = 'DeChhU9aAIHVKaRLy3kqg5QotQshuZUNUC+gYZix+RQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)