UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnRjcPxTwn3Vwzk3d9rskImD7SDSt3WlI0RwFKyAAw0='
WHERE
key_id = '1a5f192e76ddd3de99a4986b8fd4590197d1ab66229faee0c3f93b5b4cb2251a'
AND (
token = 'gnRjcPxTwn3Vwzk3d9rskImD7SDSt3WlI0RwFKyAAw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)