UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bvtr8hpNf+4eDXmJHrs6LwTkFJls5mQPExATHG0sGHk=' 
WHERE 
  key_id = '969f7019c78ee98cd9811b3126c5847684c24c89a68bb3c8be35a4d4003b7ff6' 
  AND (
    token = 'bvtr8hpNf+4eDXmJHrs6LwTkFJls5mQPExATHG0sGHk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043