UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6/08wzsR2X8lIRYCg2nMU+WTTdUE0TpUDipWXanIoOw='
WHERE
key_id = 'ab6b6e2a2a9708b8432b734e1cdc96b3eb2cefa323cdf23d5ad30c8dce3336aa'
AND (
token = '6/08wzsR2X8lIRYCg2nMU+WTTdUE0TpUDipWXanIoOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)