UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ylWQABeJMPmal73GP8nOCeUeAz5uY3Pxuhsubu4rvuU='
WHERE
key_id = 'd745ed1d99821b121d6a6911d16e6c9b0b404e5afb374656957c19d28287a724'
AND (
token = 'ylWQABeJMPmal73GP8nOCeUeAz5uY3Pxuhsubu4rvuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)