UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0kOpC09m8uxfOUBvnK8Qo9y4KVm9B8VLXibWpsYXwjc=' 
WHERE 
  key_id = 'e031d7cc2f264de53b7fb38ae91e7d20b0ba80a497c553dee568f76392550320' 
  AND (
    token = '0kOpC09m8uxfOUBvnK8Qo9y4KVm9B8VLXibWpsYXwjc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021