UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1mLEjq7YEw3ChlohExPbo6Htw7wFJ1VkwfrxlsADHCA='
WHERE
key_id = '8420da6a2aaaf0a335b439f8ae074e24a5ea62236259d336eb478d246bce3794'
AND (
token = '1mLEjq7YEw3ChlohExPbo6Htw7wFJ1VkwfrxlsADHCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)