UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'O838lKS16Sx58kc08mKUCERl8W1ha9+G8UdAvbHVUPU=' 
WHERE 
  key_id = 'f08ac3b9c920dcd5314fd927a0ebd1091564c77b924b1bdcc64ef1d0603a8487' 
  AND (
    token = 'O838lKS16Sx58kc08mKUCERl8W1ha9+G8UdAvbHVUPU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027