UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THljaVgEeVglYfrEl4ICQAmAqw7Rcq9FVvhHOPOoDMU='
WHERE
key_id = '8dbe7c2f7f35291457a5d7826352f2dfec265c67e4850df936820962b2f1780f'
AND (
token = 'THljaVgEeVglYfrEl4ICQAmAqw7Rcq9FVvhHOPOoDMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)