UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dgfbkbMCIzRg7vBq0nifcDAvHblT8XhIJ5oPveoR6dk='
WHERE
key_id = '8338857a6bc80ffa288f8395e6596b69a19c37841e6db6312b714903b7fb9d55'
AND (
token = 'dgfbkbMCIzRg7vBq0nifcDAvHblT8XhIJ5oPveoR6dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)