UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Gfs2yvuz0RVOkgQ1dWbaIrOOvnaWBDBMox9DIigAEU='
WHERE
key_id = '8e3de8043ddc3aaeceff1cccc7add4002f92ea3ca31ad1f1e9b54180f7ae7362'
AND (
token = '/Gfs2yvuz0RVOkgQ1dWbaIrOOvnaWBDBMox9DIigAEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)