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