UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fS0joCi8QAoHqiPv9SEdkCAyab+0l/G9SWk+q1Tfego=' 
WHERE 
  key_id = 'b814010d5ae9043357e8b4d95a4264d0837a5780b08848c79588af2879f852e7' 
  AND (
    token = 'fS0joCi8QAoHqiPv9SEdkCAyab+0l/G9SWk+q1Tfego=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028