UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CAs7sv0BB1qy7isqwaUw9EswD1MrWvN1nE9Tl2n0/Dg=' 
WHERE 
  key_id = '948d3802c06d9eb6780ed5c5ec5f0a3f4ac63a858ef01b2cc6c05b08bcf079ce' 
  AND (
    token = 'CAs7sv0BB1qy7isqwaUw9EswD1MrWvN1nE9Tl2n0/Dg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033