UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+0b7MtgHJa1TNBtWnJ/Xohyhvsa0L9u4hPIT9d0SWhM=' 
WHERE 
  key_id = '1f4154f1fbdfa58d1d8e1de08985135fda324598a58911d33d2ff857498161a2' 
  AND (
    token = '+0b7MtgHJa1TNBtWnJ/Xohyhvsa0L9u4hPIT9d0SWhM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041