UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JoSZf1tZiBeAj+ps/ckRKX+p4oR7uuOk9toadmLGM1A='
WHERE
key_id = 'ef7fc879e0ac01ced3165b1f9f20c2f1aa51b7c88bddec4e869a385a0b51481f'
AND (
token = 'JoSZf1tZiBeAj+ps/ckRKX+p4oR7uuOk9toadmLGM1A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)