UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3ViZMMUYF3oHeFAy5uSps+OXZNar7B83h1qzYBIEkiE='
WHERE
key_id = '8071627a8cffeb6b2c8204ba665cc5b89450e9db2b4f9e9539cac7feea40ea1a'
AND (
token = '3ViZMMUYF3oHeFAy5uSps+OXZNar7B83h1qzYBIEkiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)