UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qkhIs5kBUuAizAU55S7y161RaOY6NSF47tH3maiU7u0='
WHERE
key_id = '24520150bd7b1a2cf59b45911d672fa7fec775fd9f965447dde265b06f6cbe25'
AND (
token = 'qkhIs5kBUuAizAU55S7y161RaOY6NSF47tH3maiU7u0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)