UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nqKrEVtqGK9wgb36fjgnyUoLcJ2PTq16JTImygvindk='
WHERE
key_id = '2a2f6009ddb29d5e2814137667c33a0244fa570b8d6554ca1f8e6af452c02f30'
AND (
token = 'nqKrEVtqGK9wgb36fjgnyUoLcJ2PTq16JTImygvindk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)