UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DOenR4p03NMF1lKzwfi1N9ADrW8OFWcJS8xBAcd8CEk=' 
WHERE 
  key_id = 'd8520d0ed5b55286d50347faaf962eb1c07961cb574beedd46a7726715f5a110' 
  AND (
    token = 'DOenR4p03NMF1lKzwfi1N9ADrW8OFWcJS8xBAcd8CEk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036