UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MkkbBkiiG32WBw6NKinFKWDMexuDR86yPONs828yqU4=' 
WHERE 
  key_id = '1f696351caa2555bc362dd8eb5bf4f28fee0726683a5b274bc8562a1470fbab6' 
  AND (
    token = 'MkkbBkiiG32WBw6NKinFKWDMexuDR86yPONs828yqU4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047