UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JJBfy6WVNsyN4yyH8Iil4JOYFdIboFVVd/23u1mBxQk='
WHERE
key_id = 'd040c8afdef6b52ac50bb0051b36443f84c0352200e42e275f9db9c8d0a5025d'
AND (
token = 'JJBfy6WVNsyN4yyH8Iil4JOYFdIboFVVd/23u1mBxQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)