UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1u4PxnTUmvnurAOPMK9Y1qUWgo4/28JqiZ+uvWVpW2c=' 
WHERE 
  key_id = 'fa1114de8c8c13dbf1d84b8ed6efde31794ad16c5d7a313e4ec67f4ee3cca71c' 
  AND (
    token = '1u4PxnTUmvnurAOPMK9Y1qUWgo4/28JqiZ+uvWVpW2c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038