UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmIeYrtyYiM1i/2WY0w10P3VdjKkUMlRMlxuhzFEX2c='
WHERE
key_id = '0b9b56f3bc21caa89c49da7036d76f4023c692e30ee2fc70996974b24afca499'
AND (
token = 'CmIeYrtyYiM1i/2WY0w10P3VdjKkUMlRMlxuhzFEX2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)