UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vy4BRBX1dcdJHnbJlE/1MUCOtkUf3UObnAq6d4HxswY='
WHERE
key_id = 'd5bf7907a7700e7a7c4092a36223f98346b58feeb0aed2115383ac6d177ac0ae'
AND (
token = 'Vy4BRBX1dcdJHnbJlE/1MUCOtkUf3UObnAq6d4HxswY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)