UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRW4SpYpwj1xVMN8x1WbJ4tiaNQ+ge3WwT7VDWUJJKI='
WHERE
key_id = '26de9e3025873756727e33140335dbe7a18700a6eef01a9c1a593fb29befb89f'
AND (
token = 'zRW4SpYpwj1xVMN8x1WbJ4tiaNQ+ge3WwT7VDWUJJKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)