UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1FLmAGTLntwsZ9WtphB9ByHmz5DrPWbswb7YOHCXLMc='
WHERE
key_id = '47a0d6c5b997d6f216220bde587513829474daa7095e63355884d419e09023e5'
AND (
token = '1FLmAGTLntwsZ9WtphB9ByHmz5DrPWbswb7YOHCXLMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)