UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Eztcz0vWd3fjnOo3DOESNOlUe2offHS3QY3msi3BHU='
WHERE
key_id = '6b52d9117212ec80ebadd23a2daf7818a0bb2c4dfb77049c4c20dcfc3ca282c0'
AND (
token = '7Eztcz0vWd3fjnOo3DOESNOlUe2offHS3QY3msi3BHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)