UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIIDNG81hMZb5e+cOgSWH9scG4p6svHmB3lMj/YZEKc='
WHERE
key_id = '9f72647ce0963307b0f85a7125fe5c2bc645c567ebbb6ba1e26fa56e28649b2a'
AND (
token = 'gIIDNG81hMZb5e+cOgSWH9scG4p6svHmB3lMj/YZEKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)