UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7lJLDSsjtuydoGSc1TaJBGfqM2aQAVgZLve+HkfUSbA=' 
WHERE 
  key_id = '56aa18a5437e44567af245a3da1737e998ba6ee02396027147a0e1f3d7fdc5d0' 
  AND (
    token = '7lJLDSsjtuydoGSc1TaJBGfqM2aQAVgZLve+HkfUSbA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041